Re: [GENERAL] Large Object questions... - Mailing list pgsql-general

From Herouth Maoz
Subject Re: [GENERAL] Large Object questions...
Date
Msg-id l03130302b3c9f712a94d@[147.233.159.109]
Whole thread Raw
In response to Re: [GENERAL] Large Object questions...  ("John Huttley" <john@mwk.co.nz>)
List pgsql-general
At 08:31 +0300 on 30/07/1999, John Huttley wrote:


> I'm busy writing a faxserver application where all the fax page data is
> stored as a blob.
>
> Its just so easy to use...

How will you be backing it up? pg_dump never dumped large objects.

IMO, if you need a specialized backup script, plus a non-standard interface
for writing into them and reading from them, and they are not deleted when
you drop the row referring to them, then you may as well use files, and
store only the path in Postgres for easy lookup.

Herouth

--
Herouth Maoz, Internet developer.
Open University of Israel - Telem project
http://telem.openu.ac.il/~herutma



pgsql-general by date:

Previous
From: Michael Simms
Date:
Subject: big copy tasks
Next
From: Herouth Maoz
Date:
Subject: Re: [GENERAL] Search